﻿<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../Connections/test.jsp" %>
<%
  Driver DriverRecordset1 = (Driver) Class.forName(MM_test_DRIVER).newInstance();
  Connection ConnRecordset1 = DriverManager.getConnection(MM_test_STRING, MM_test_USERNAME, MM_test_PASSWORD);
  PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT *  FROM shengwuyixue.teacher where shengwuyixue.teacher.zhicheng='zhuan'");
  ResultSet Recordset1 = StatementRecordset1.executeQuery();
  boolean Recordset1_isEmpty = !Recordset1.next();
  boolean Recordset1_hasData = !Recordset1_isEmpty;
  Object Recordset1_data;
  int Recordset1_numRows = 0;
%>
<%
  Driver DriverRecordset2 = (Driver) Class.forName(MM_test_DRIVER).newInstance();
  Connection ConnRecordset2 = DriverManager.getConnection(MM_test_STRING, MM_test_USERNAME, MM_test_PASSWORD);
  PreparedStatement StatementRecordset2 = ConnRecordset2.prepareStatement("SELECT *  FROM shengwuyixue.teacher where shengwuyixue.teacher.zhicheng='jian'");
  ResultSet Recordset2 = StatementRecordset2.executeQuery();
  boolean Recordset2_isEmpty = !Recordset2.next();
  boolean Recordset2_hasData = !Recordset2_isEmpty;
  Object Recordset2_data;
  int Recordset2_numRows = 0;
%>
<%
  Driver DriverRecordset3 = (Driver) Class.forName(MM_test_DRIVER).newInstance();
  Connection ConnRecordset3 = DriverManager.getConnection(MM_test_STRING, MM_test_USERNAME, MM_test_PASSWORD);
  PreparedStatement StatementRecordset3 = ConnRecordset3.prepareStatement("SELECT *  FROM shengwuyixue.teacher where shengwuyixue.teacher.zhicheng='xing'");
  ResultSet Recordset3 = StatementRecordset3.executeQuery();
  boolean Recordset3_isEmpty = !Recordset3.next();
  boolean Recordset3_hasData = !Recordset3_isEmpty;
  Object Recordset3_data;
  int Recordset3_numRows = 0;
%>
<%
  int Repeat1__numRows = -1;
  int Repeat1__index = 0;
  Recordset1_numRows += Repeat1__numRows;
%>
<%
  int Repeat2__numRows = -1;
  int Repeat2__index = 0;
  Recordset2_numRows += Repeat2__numRows;
%>
<%
  int Repeat3__numRows = -1;
  int Repeat3__index = 0;
  Recordset3_numRows += Repeat3__numRows;
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
  <title>北京交通大学计算机与信息技术学院生物医学工程系</title>
  <link href="<%=request.getContextPath()%>/include/css/css.css" rel="stylesheet" type="text/css"/>
  <style type="text/css">
    <!--
    .STYLE1 {
      font-size: 16px;
      font-weight: bold;
    }

    .STYLE3 {
      font-size: 18px;
      font-weight: bold;
    }

    .STYLE5 {
      font-size: 16px
    }

    .STYLE6 {
      font-family: "新宋体"
    }

    .STYLE7 {
      font-size: 16;
      font-weight: bold;
      color: #FFFFFF;
    }

    -->
  </style>
</head>
<body>
<div class="zhong">

  <jsp:include page="/include/banner.jsp"/>
  <jsp:include page="/include/menu.jsp"/>

  <div class="main">
    <div class="left">
      <div class="box_1">
        <div class="left_title STYLE1">师资队伍</div>
        <div class="left_news">
          <ul>
            <li><a href="teacher.jsp" class="hover">专职教师</a></li>
            <li><a href="professor.jsp">兼职教授</a></li>

            <li><a href="administrator.jsp">行政人员</a></li>
          </ul>
        </div>
      </div>
      <!--

     <div class="box_1">
         <div class="left_title STYLE1">合作交流</div>
         <div class="left_nr">
           <ul>
             <li><a href="">项目合作交流</a></li>
             <li><a href="">教学合作交流</a></li>
       <li><a href="">公司企业交流</a></li>
             <li><a href="">国内合作交流</a></li>
             <li><a href="">国外合作交流</a></li>

           </ul>
         </div>
       </div>
       <div class="box_1" style="margin:0px;">
         <div class="left_title STYLE1">信息服务</div>
         <div class="left_nr">
           <ul>
             <li><a href="#">资源下载</a></li>
        <li><a href="#">资源上传</a></li>
         <li><a href="#">注册登录</a></li>
          <li><a href="#">后台管理</a></li>


           </ul>
         </div>
       </div>

     -->

    </div>
    <div class="right">
      <div class="right_title STYLE5 STYLE6">
        <p>教员构成</p>
        <p>&nbsp;</p>
        <p>&nbsp;</p>
        <p>专职教师：</p>
        <p>&nbsp;</p>

        <% while ((Recordset1_hasData) && (Repeat1__numRows-- != 0)) { %>
        <%=(((Recordset1_data = Recordset1.getObject("teachername")) == null || Recordset1.wasNull()) ? "" : Recordset1_data)%>
        <%
            Repeat1__index++;
            Recordset1_hasData = Recordset1.next();
          }
        %>

        <p>&nbsp;</p>
        <p>&nbsp;</p>
        <p>兼职教授：</p>
        <p>&nbsp;</p>

        <% while ((Recordset2_hasData) && (Repeat2__numRows-- != 0)) { %>
        <p><%=(((Recordset2_data = Recordset2.getObject("teachername")) == null || Recordset2.wasNull()) ? "" : Recordset2_data)%>
        </p>
        <%
            Repeat2__index++;
            Recordset2_hasData = Recordset2.next();
          }
        %>
        <p>&nbsp;</p>
        <p>行政人员：</p>
        <p>&nbsp;</p>

        <% while ((Recordset3_hasData) && (Repeat3__numRows-- != 0)) { %>
        <p><%=(((Recordset3_data = Recordset3.getObject("teachername")) == null || Recordset3.wasNull()) ? "" : Recordset3_data)%>
        </p>
        <%
            Repeat3__index++;
            Recordset3_hasData = Recordset3.next();
          }
        %>
        <p>&nbsp;</p>
        <p>&nbsp;</p>
      </div>
    </div>
    <p></p>
    <!--这里是链接模块,已删除，可自行添加-->
    <div class="clear"></div>
    <div class="clear"></div>
  </div>


  <div class="clear"></div>
</div>
<div class="bottom">
  <p>地址：北京市海淀区上园村3号北京交通大学信息中心　邮编：100044　 </p>
  <p>北京交通大学计算机与信息技术学院生物医学工程系保留网站所有权利</p>
  <p> 未经允许不得复制、镜像</p>
  <p>京公网安备：110402430059 号</p>
  <br/>
  版权所有&copy;ouchanghai,cit.bjtu.
</div>
</div>
<script src="<%=request.getContextPath()%>/include/js/meun.js" type="text/javascript"></script>
</body>
</html>
<%
  Recordset1.close();
  StatementRecordset1.close();
  ConnRecordset1.close();
%>
<%
  Recordset2.close();
  StatementRecordset2.close();
  ConnRecordset2.close();
%>
<%
  Recordset3.close();
  StatementRecordset3.close();
  ConnRecordset3.close();
%>
